Notebook for Social audit

This is a notebook processing the questionnaire responses for social audit work done with the residents of Sri Tanjung Apartment in USJ 16.

Text in quoted blocks like this as well as data presented in tabular form and graphs can be copied and used in final report

Setup

Quick setup to load the data

Distribution of responses for each question

These are the distribution of responses for each questions (some further broken down as needed).

Demographic study

Gender

The following cell shows the distribution of gender, unfortunately, as the field was only added after some time the questionnaire went online so. In total there were 28 entries where gender isn't captured.

Age

The following cell shows the age distribution of the respondent.

Education level

The following shows the distribution of education level

Employment status

The following shows the distribution of employment

Household income

The following cell shows the distribution of household income and the respective histogram.

Family size

The following shows the distribution of family size

Accessing the Internet and Challenges

How do you access government services

The following shows how respondents access government services, please note that the options are not mutually exclusive

Do you own and often use these equipments

Do you use internet for as long as you wanted

Have you used free WiFi services in public areas in the past

Have you used free WiFi services provided by the government

Are you able to work from home

Are you being comfortable with working from home

Are your family members (if applicable) able to learn online?

Are they comfortable with learning online?

How much are you willing to pay monthly for internet access service?

How much are you willing to pay for a new computer or laptop

How much are you willing to pay for a new smartphone or tablet?

Which of the following devices/services do you think are essential for the time being?

other essential devices/services

Challenges encountered in getting internet access

Problem accessing the internet due to data privacy concern

Problem accessing the internet due to other challenges

What is your goal when accessing the internet

Frequently accessed web services

Type of internet service used

How does the Internet change your life?

Change in social life

Change in personal finances

Change in service access

Change in Social / Self-awareness

Your opinion on the use of the internet in a family

Your opinion on the use of the internet based on personal experience

What makes you worried about the internet?

Have you experienced the following while using the internet?

Do you agree with the following

Your family does not like you to access the internet

Correlation study

This is the part where I start calculating correlation.

vs Household income

Correlation between household income and the methods used to access government service

We fail to reject the hypothesis where there household income is independent from the method used to access the government service at alpha value being set to 0.05 (Which means the same conclusion can be drawn 95% of the time should this study is repeated). Therefore no further study was conducted to test for correlation between the two factors.

Correlation between household income vs the ownership of different types of devices

We fail to reject the hypothesis where there household income is independent from the ownership of different types of devices at alpha value being set to 0.05.

Household income vs whether respondents get to access the internet as much as they desire

We fail to reject the hypothesis where there household income is independent from whether respondents get to access the internet as much as he/she desires at alpha value being set to 0.05.

Household income vs prior experience in usage of public wifi

We fail to reject the hypothesis where there household income is independent from whether respondents used public wifi at alpha value being set to 0.05.

Household income vs prior experience in usage of public wifi provided by the government

We fail to reject the hypothesis where there household income is independent from whether respondents used public wifi provided by the government at alpha value being set to 0.05.

Household income vs ability to work from home

We fail to reject the hypothesis where there household income is independent from whether respondents could work from home provided by the government at alpha value being set to 0.05.

Household income vs Comfortable working from home

We fail to reject the hypothesis where there household income is independent from whether respondents could work from home comfortably provided by the government at alpha value being set to 0.05.

Household income vs can e-learn

Household income vs comfortable e-learn

Household income vs budget for internet access

Household income vs Budget for computer / laptop

Household income vs budget for mobile devices

vs Education level

Correlation between education level and the methods used to access government service

Correlation between education level vs the ownership of different types of devices

Education level vs whether respondents get to access the internet as much as they desire

Education level vs prior experience in usage of public wifi

Education level vs prior experience in usage of public wifi provided by the government

Education level vs ability to work from home

Education level vs Comfortable working from home

Education level vs can e-learn

Education level vs comfortable e-learn

Education level vs budget for internet access

Education level vs Budget for computer / laptop

Education level vs budget for mobile devices

vs Age

Age vs method used to access government service

Age vs the ownership of different types of device

Age vs whether respondents get to access the internet as much as he/she desires

Age vs prior experience in usage of public wifi

Age vs prior experience in usage of public wifi provided by the government

Age vs ability to work from home

Age vs being comfortable working from home

Age vs can e-learn

Age vs comfortable e-learn

Age vs budget for internet access

Age vs Budget for computer / laptop

Age vs budget for mobile devices

vs Gender (Skipping correlation tests)

Gender vs methods used to access government service

Gender vs ownership of different types of devices

Gender vs whether respondents get to access the internet as much as they desire

Gender vs prior experience in usage of public wifi

Gender vs prior experience in usage of public wifi provided by the government

Gender vs ability to work from home

Gender vs Comfortable working from home

Gender vs can e-learn

Gender vs comfortable e-learn

Gender vs budget for internet access

Gender vs budget for computer / laptop

Gender vs budget for mobile devices

Employment status vs

Employment status vs methods used to access government service

Employment status vs the ownership of different types of devices

Employment status vs whether respondents get to access the internet as much as they desire

Employment status vs prior experience in usage of public wifi

Employment status vs prior experience in usage of public wifi provided by the government

Employment status vs ability to work from home

Employment status vs being comfortable working from home

Employment status vs can e-learn

Employment status vs comfortable e-learn

Employment status vs budget for internet access

Employment status vs budget for computer / laptop

Employment status vs budget for mobile devices